/*-------------------<!--Start of Description-->---------------------\
| Print datasets;                                                    |
|---------------------<!--End of Description-->----------------------|
|--------------------------------------------------------------------|
|------------<!--Start of Files or Arguments Needed-->---------------|
| No argument is needed; but there are several optional arguement:   |
| indata: if no indata is provided, print the latest data generated; |
| var: the variable names to be printed; if not provided, print all; |
| where: define a subset of the datasets; if not provided, print all;|
| groupby: groupby statement, how do you want to group the variables;|
| having: use the statistics associated with groupby to select data; |
| orderby: print the output data in the order of which variable;     |
| outdata: output dataset; if no, just print to list without output; |
|---------------<!--End of Files Arguments Needed-->-----------------|
|--------------------------------------------------------------------|
|------------------<!--Start of Files Created-->---------------------|
| Example:                                                           |
| data one;                                                          |
|    input str $ x y z;                                              |
|    LABEL str='character' X='numeric x' y='numeric y' z='numeric z';|
|    datalines;                                                      |
| this 2 1 213                                                       |
| is 23 1 323                                                        |
| a 1243 23 12                                                       |
| test 131 4576 1                                                    |
| to 124 23 32                                                       |
| check 1245 2 3                                                     |
| to 23 32 44                                                        |
|  see 2345 43 65                                                    |
|  if 23 123 090                                                     |
|  print 23 34 21                                                    |
|  works 21 23 322                                                   |
|  ; %prt(one, (distinct y, count(*) as numx), groupby=(y),          |
|         orderby=(numx, desc y));                                   |
| Usgae: %prt(indata=, var=, inobs=, outobs=, groupby=, having=,     |
|             where=, orderby=, outdata=)/parmbuff;                  |
\-------------------<!--End of Files Created-->---------------------*/
%macro prt/parmbuff;
/*------------------------------------\
| Copy Right: Duo Zhou;               |
| Created: 6-16-2001 8:32pm;          |
| Purpose: Custimable print procedure;|
\------------------------------------*/
%local _newstr_ _dlen_ indata var inobs outobs groupby having where orderby outdata
       _title_1 _title_2 _title_3 _title_4 _title_5 _title_6 _title_7 _title_8 _title_9 _title10;
%let syspbuff=%sysfunc(translate(%quote(%substr(%quote(%trim(%quote(%left(%quote(&syspbuff))))), 2, %eval(%length(%trim(%quote(%left(%quote(&syspbuff)))))-2))), %str(%'), %str(%")));
%let _dlen_=$%trim(%left(%eval(%length(&syspbuff)+20))); %let _tmplast_=&syslast; %let indata=; %let var=; %let inobs=; %let outobs=; 
%let groupby=; %let having=; %let where=; %let orderby=; %let outdata=; %let _viewexist_=; %let _datao_=; %let _newstr_=;
%let _xprtrx_=%sysfunc(rxparse($(1))); %let _xprtpos_=0; %let _xprtlen_=0; %let _xprtoldstr_=; %let _xprtnewstr_=; %let _prttm_=%sysfunc(datetime());
%let _title_1=; %let _title_2=; %let _title_3=; %let _title_4=; %let _title_5=; %let _title_6=; %let _title_7=; %let _title_8=; %let _title_9=; %let _title_10=;
%do %while( %sysfunc(rxmatch(&_xprtrx_, %quote(&syspbuff))) );
  %syscall rxsubstr(_xprtrx_, syspbuff, _xprtpos_, _xprtlen_);
  %let _xprtoldstr_=%quote(%substr(%quote(&syspbuff), &_xprtpos_, &_xprtlen_));
  %let _xprtnewstr_=%quote(%sysfunc(translate(%quote(&_xprtoldstr_), À, %quote(%(), Á, %quote(%)), ´, %quote(,), ®, %quote( ))));
  %let syspbuff=%sysfunc(tranwrd(%quote(&syspbuff), %quote(&_xprtoldstr_), %quote(&_xprtnewstr_)));
  %let _xprtpos_=0; %let _xprtlen_=0; %let _xprtoldstr_=; %let _xprtnewstr_=;
%end; %let _newstr_=&syspbuff;
%local _xvarcnt_ _xvar_; %let _xvarcnt_=0;
%do %while(%length(%qscan(%nrbquote(&_newstr_), %eval(&_xvarcnt_+1), %nrbquote(,))));
  %let _xvarcnt_=%eval(&_xvarcnt_+1); %let _xvar_=%nrbquote(%qscan(%nrbquote(&_newstr_), &_xvarcnt_, %nrbquote(,)));
  %let _xvar_=%sysfunc(translate(%quote(&_xvar_), '(', 'À', ')', 'Á', ',', '´', ' ', '®')); 
  %let _x2_=%trim(%left(%qscan(%quote(&_xvar_), 1, %str(=))));
  %let _x3_=%substr(%quote(&_xvar_), %eval(%index(%quote(&_xvar_),%str(=))+1), %eval(%length(&_xvar_)-%index(%quote(&_xvar_),%str(=))));
   %if (not %index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(&_xvar_))))), %str(=))) and
     ((%quote(&_xvarcnt_) = %quote(1)) or (%quote(&_xvarcnt_) = %quote(2))) %then %do;
    %if (%index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(&_x2_))))), %str(%()) eq 1) and
       (%index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(%sysfunc(reverse(&_x2_))))))), %str(%))) eq 1) %then
      %let _x3_=%substr(%quote(%trim(%quote(%left(%quote(&_x2_))))), 2, %eval(%length(%trim(%quote(%left(%quote(&_x2_)))))-2));
    %if (%quote(&_xvarcnt_) = %quote(1)) %then %let indata=&_x3_; %else %let var=&_x3_;
  %end;
  %else %if (%index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(&_x3_))))), %str(%()) eq 1) and
       (%index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(%sysfunc(reverse(&_x3_))))))), %str(%))) eq 1) and (%index(%nrbquote(upcase(%nrbquote(%sysfunc(compress(%nrbquote(&_x2_)))))), WHERE=) le 1) %then
      %let &_x2_=%substr(%quote(%trim(%quote(%left(%quote(&_x3_))))), 2, %eval(%length(%trim(%quote(%left(%quote(&_x3_)))))-2));
  %else %let &_x2_=&_x3_;
%end;
%if (%length(&indata) le 0) %then %let indata=&syslast;
%if (%length(&var) le 0) %then %let _allvars_=*;
%else %do;
  %if (%index(%quote(&var), %str(,))) %then %let vardlm=%quote(,);
  %else %let vardlm=%quote( );
  %if (%index(%quote(&var), %str(-))) %then %do;
    %let _convar_=; %let _dummyvar_=&var;
    %do %while(%index(%quote(&var), %str(-)));
      %let _sub1var_=%substr(%quote(&var), 1, %eval(%index(%quote(&var), %str(-))-1));
      %let var=%substr(%quote(&var), %eval(%index(%quote(&var), %str(-))+1), %eval(%length(&var)-%index(%quote(&var), %str(-)))); %let _tmpvari_=0;
      %do %while(%length(%qscan(%nrbquote(&_sub1var_), %eval(&_tmpvari_+1), %nrbquote(&vardlm))));
        %let _tmpvari_=%eval(&_tmpvari_+1); %let _tmp1var_=%nrbquote(%qscan(%nrbquote(&_sub1var_), &_tmpvari_, %%nrbquote(&vardlm)));
        %if (%length(%qscan(%nrbquote(&_sub1var_), %eval(&_tmpvari_+1), %nrbquote(&vardlm)))) %then %do;
          %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%quote(%left(%quote(&_tmp1var_))));
          %else %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
        %end;
        %else %if ( %eval(%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp1var_)))+1)) %then %do;
          %let _arrvarbeg_=%substr(%quote(&_tmp1var_), %eval(%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp1var_)))+1),
                %eval(%length(&_tmp1var_)- %eval(%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp1var_))))));
          %let _dummykeyword_=;
          %let _arrvarbroot_=%substr(%quote(&_tmp1var_), 1, %sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp1var_))));
          %if (%sysfunc(indexw(%quote(%upcase(&_arrvarbroot_)),%quote(DISTINCT)))) %then %do;
            %let _dummykeyword_=distinct ;
            %let _arrvarbroot_=%sysfunc(tranwrd(%quote(%upcase(&_arrvarbroot_)),%quote(DISTINCT),%quote()));
          %end;
          %if (%quote(&var) ne) %then %do; %let _tmp2var_=%nrbquote(%qscan(%nrbquote(&var), 1, %%nrbquote(&vardlm)));
            %if (%sysfunc(rxmatch(%sysfunc(rxparse($d $s)),&_tmp2var_))) %then %do;
              %let _arrvarend_=%substr(%quote(&_tmp2var_), %eval(%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp2var_)))+1),
                             %eval(%length(&_tmp2var_)- %eval(%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp2var_))))));
              %let _arrvareroot_=%substr(%quote(&_tmp2var_), 1,%sysfunc(rxmatch(%sysfunc(rxparse($- ($a|_))),%quote(&_tmp2var_))));
              %if (%quote(%lowcase(&_arrvarbroot_)) eq %quote(%lowcase(&_arrvareroot_))) %then %do;
                %do _locali_=&_arrvarbeg_ %to %eval(&_arrvarend_-1);
                  %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%left(&_arrvarbroot_))%trim(%left(&_locali_));
                  %else %do;
                    %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
                      %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
                        %let _convar_=%trim(%quote(%left(%quote(&_convar_))))(%quote(&vardlm) %trim(%left(&_arrvarbroot_))%trim(%left(&_locali_));
                      %else %let _convar_=%trim(%quote(%left(%quote(&_convar_)))) %trim(%left(&_arrvarbroot_))%trim(%left(&_locali_));
                    %end;
                    %else %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%left(&_arrvarbroot_))%trim(%left(&_locali_));
                  %end;
                %end;
              %end;
              %else %do;
                %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%quote(%left(%quote(&_tmp1var_))));
                %else %do;
                  %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
                    %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
                      %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
                    %else %let _convar_=%trim(%quote(%left(%quote(&_convar_)))) %trim(%quote(%left(%quote(&_tmp1var_))));
                  %end;
                  %else %let _convar_=%trim(%quote(%left(&_convar_)))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
                %end;
                %put ==> Alert! Variable name &_tmp1var_ and &_tmp2var_ do not have the same pattern!;
              %end;
            %end;
            %else %do;
              %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%quote(%left(%quote(&_tmp1var_))));
              %else %do;
                %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
                  %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
                    %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
                  %else %let _convar_=%trim(%quote(%left(%quote(&_convar_)))) %trim(%quote(%left(%quote(&_tmp1var_))));
                %end;
                %else %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
              %end;
              %put ==> Alert! Variable name &_tmp2var_ does not have a numeric suffix!;
            %end;
          %end;
          %else %do;
            %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%quote(%left(%quote(&_tmp1var_))));
            %else %do;
              %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
                %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
                  %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
                %else %let _convar_=%trim(%quote(%left(%quote(&_convar_)))) %trim(%quote(%left(%quote(&_tmp1var_))));
              %end;
              %else %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
            %end;
            %put ==> Alert! No variable names are provided after &_tmp1var_ -!;
          %end;
        %end;
        %else %do;
          %if (%quote(&_convar_) eq) %then %let _convar_=%trim(%quote(%left(%quote(&_tmp1var_))));
          %else %do;
            %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
              %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
                %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
              %else %let _convar_=%trim(%quote(%left(%quote(&_convar_)))) %trim(%quote(%left(%quote(&_tmp1var_))));
            %end;
            %else %let _convar_=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&_tmp1var_))));
          %end;
          %put ==> Alert! Variable name &_tmp1var_ does not have a numeric suffix!;
        %end;
      %end;
    %end;
    %if (%index(%quote(%upcase(&_dummyvar_)), %quote(DISTINCT ))) or (%sysfunc(indexw(%quote(%upcase(&_dummyvar_)), %quote(AS)))) %then %do;
      %if (%quote(%upcase(&_convar_)) ne %quote(DISTINCT)) and (%substr(%quote(%upcase(%trim(%quote(%left(%quote(&_convar_)))))), %eval(%length(%trim(%quote(%left(%quote(&_convar_)))))-2),3) ne %quote( AS)) %then
        %let var=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&var))));
      %else %let var=%trim(%quote(%left(%quote(&_convar_)))) %trim(%quote(%left(%quote(&var))));
    %end;
    %else %let var=%trim(%quote(%left(%quote(&_convar_))))%quote(&vardlm) %trim(%quote(%left(%quote(&var))));
  %end;
  %if (not %index(%quote(&var), %quote(,))) and (not %index(%quote(%upcase(&var)), %quote(DISTINCT ))) and
     (not %sysfunc(indexw(%quote(%upcase(&var)), %quote(AS)))) %then %do;
    %if (%sysfunc(index(%quote(&var),_ALL_))) %then %let var=*;
    %else %if (%sysfunc(index(%quote(%upcase(&var)),_CHARACTER_))) %then %do;
      %if (%sysfunc(exist(&indata))) %then %do; %let _indsid_=%sysfunc(open(&indata)); %let _innvars_=%sysfunc(attrn(&_indsid_,NVARS)); %let _convar_=;
        %do _invari_=1 %to &_innvars_; %let _invtype_=%sysfunc(vartype(&_indsid_, &_invari_));
          %if (not %index(%quote(%upcase(&_invtype_)),%quote(N))) %then %let _convar_= %trim(%left(&_convar_)) %sysfunc(varname(&_indsid_,&_invari_));
        %end; %let _invrc_=%sysfunc(close(&_indsid_)); %let var=&_convar_;
      %end;
    %end;
    %else %if (%sysfunc(index(%quote(%upcase(&var)),_NUMERIC_))) %then %do;
      %if (%sysfunc(exist(&indata))) %then %do; %let _indsid_=%sysfunc(open(&indata)); %let _innvars_=%sysfunc(attrn(&_indsid_,NVARS)); %let _convar_=;
        %do _invari_=1 %to &_innvars_; %let _invtype_=%sysfunc(vartype(&_indsid_, &_invari_));
          %if (%index(%quote(&_invtype_),%quote(N))) %then %let _convar_= %trim(%left(&_convar_)) %sysfunc(varname(&_indsid_,&_invari_));
        %end; %let _invrc_=%sysfunc(close(&_indsid_)); %let var=&_convar_;
      %end;
    %end;
    %else %do;  %let _jvar_=0;
      %do %while(%length(%qscan(%quote(&var), %eval(&_jvar_+1), %quote( ))));
        %let _jvar_=%eval(&_jvar_+1); %let _varj_=%qscan(%quote(&var), &_jvar_, %quote( ));
        %if (%index(%BQUOTE(%trim(%BQUOTE(%left(%BQUOTE(&_varj_))))), %str(%()))
           and (not %index(%quote(%upcase(%sysfunc(compress(%quote(&_varj_))))),%str(LABEL=))) %then
          %let _varj_=&_varj_ label="&_varj_";
        %if (%quote(&_jvar_) eq 1) %then %let _allvars_=&_varj_;
        %else %if (%length(&_varj_) gt 0) and (%quote(%upcase(&_allvars_)) ne %quote(DISTINCT)) %then
          %let _allvars_=%trim(%bquote(%left(%bquote(&_allvars_)))), &_varj_;
        %else %if (%length(&_varj_) gt 0) and (%quote(%upcase(&_allvars_)) eq %quote(DISTINCT)) %then
          %let _allvars_=%trim(%bquote(%left(%bquote(&_allvars_)))) &_varj_;
      %end;
    %end;
  %end; %else %let _allvars_=&var;
%end;
%if (%length(&groupby) gt 0) %then %do;
  %if (not %index(%quote(&groupby), %quote(,))) %then %do; %let _jgroupby_=0; %let _allgroupbys_=;
    %do %while(%length(%qscan(%quote(&groupby), %eval(&_jgroupby_+1), %quote( ))));
      %let _jgroupby_=%eval(&_jgroupby_+1); %let _groupbyj_=%qscan(%quote(&groupby), &_jgroupby_, %quote( ));
      %if (%quote(&_jgroupby_) eq %quote(1)) %then %let _allgroupbys_=&_groupbyj_;
      %else %if (%length(&_groupbyj_) gt 0) %then %let _allgroupbys_=%trim(%quote(%left(%quote(&_allgroupbys_)))), &_groupbyj_;
    %end; %let groupby=&_allgroupbys_;
  %end;
%end;
%if (%length(&orderby) gt 0) %then %do;
  %if (not %index(%quote(&orderby), %quote(,))) and (not %sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESC)))) and
     (not %sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESCENDING)))) and
     (not %sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASC)))) and
     (not %sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASCENDING)))) %then %do;
    %let _jorderby_=0; %let _allorderbys_=;
    %do %while(%length(%qscan(%quote(&orderby), %eval(&_jorderby_+1), %quote( ))));
      %let _jorderby_=%eval(&_jorderby_+1); %let _orderbyj_=%qscan(%quote(&orderby), &_jorderby_, %quote( ));
      %if (%quote(&_jorderby_) eq %quote(1)) %then %let _allorderbys_=&_orderbyj_;
      %else %if (%length(&_orderbyj_) gt 0) %then %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), &_orderbyj_;
    %end; %let orderby=&_allorderbys_;
  %end;
  %else %do; %let _jorderby_=0; %let _allorderbys_=;
    %do %while(%length(%qscan(%quote(&orderby), %eval(&_jorderby_+1), %quote(,))));
      %let _jorderby_=%eval(&_jorderby_+1); %let _orderbyj_=%qscan(%quote(&orderby), &_jorderby_, %quote(,));
      %if (%quote(&_jorderby_) eq %quote(1)) %then %do;
        %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESC)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(DESC), %quote( ))))))) DESC;
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESCENDING)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(DESCENDING), %quote( ))))))) DESC;
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASC)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(ASC), %quote( ))))))) ASC;
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASCENDING)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(ASCENDING), %quote( ))))))) ASC;
        %else %let _allorderbys_=&_orderbyj_;
      %end;
      %else %if (%length(&_orderbyj_) gt 0) %then %do;
        %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESC)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), %trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(DESC), %quote( ))))))) DESC;
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(DESCENDING)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), %trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(DESCENDING), %quote( ))))))) DESC;
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASC)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), %trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(ASC), %quote( )))))));
        %else %if (%sysfunc(indexw(%quote(%upcase(&orderby)), %quote(ASCENDING)))) %then
          %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), %trim(%quote(%left(%quote(%sysfunc(tranwrd(%quote(%upcase(&_orderbyj_)), %quote(ASCENDING), %quote( )))))));
        %else %let _allorderbys_=%trim(%quote(%left(%quote(&_allorderbys_)))), &_orderbyj_;
      %end;
    %end; %let orderby=&_allorderbys_;
  %end;
%end; %let _idata_=0;
%do %while(%length(%qscan(%quote(&indata), %eval(&_idata_+1), %str( ,))));
  %let _idata_=%eval(&_idata_+1); %let _datai_=%qscan(%quote(&indata), &_idata_, %str( ,));
  %if (%quote(&outdata) ne) %then %let _datao_=%qscan(%quote(&outdata), &_idata_, %str( ,));
  %if (%sysfunc(exist(&_datai_))) or (%sysfunc(exist(&_datai_, VIEW))) %then %do;
    options nonotes;
    proc sql %if (%length(&inobs) gt 0) %then %do; inobs=&inobs %end;
          %if (%length(&outobs) gt 0) %then %do; outobs=&outobs %end;;
      create table _prtmp1_ as select &_allvars_ from &_datai_ 
      %if (%length(&where) gt 0) %then where &where;
      %if (%length(&groupby) gt 0) %then group by &groupby;
      %if (%length(&having) gt 0) %then having &having;
      %if (%length(&orderby) gt 0) %then order by &orderby;;
    %local _prtmp1dsid_ _prtmp1nobs_ _prtmp1rc_; %let _prtmp1dsid_=%sysfunc(open(_prtmp1_));
    %if &_prtmp1dsid_ %then %do; %let _prtmp1nobs_=%sysfunc(attrn(&_prtmp1dsid_,NOBS)); %let _prtlabel_=LABEL ; %let _prtmp1nvars_=%sysfunc(attrn(&_prtmp1dsid_,NVARS)); %let _prtvariable_=; 
      %do _chki_=1 %to &_prtmp1nvars_; 
        %let _prtvar_=%sysfunc(varname(&_prtmp1dsid_,&_chki_)); %let _prtvariable_=%trim(%left(&_prtvariable_)) %trim(%left(&_prtvar_)); 
        %let _prtlabel_=%trim(%bquote(%left(%bquote(&_prtlabel_)))) %trim(%left(&_prtvar_))="%trim(%bquote(%left(%bquote(%trim(%bquote(%left(%bquote(%sysfunc(varlabel(&_prtmp1dsid_,&_chki_)))))) %quote(<%trim(%bquote(%left(%bquote(&_prtvar_))))>)))))";
      %end; %let _prtmp1rc_=%sysfunc(close(&_prtmp1dsid_)); 
    %end;
    %else %do; %put NOTE: No observations are selected!; %goto finish; %end;
    %if (%quote(&_prtmp1nobs_) le 0) %then %do; %put --> Alert! No observations were printed!; %goto finish; %end; %local zero;
    proc contents data=_prtmp1_ out=_prtmp1cnt_(index=(varnum)) noprint;
    %do _prtrszi_=1 %to &_prtmp1nobs_; %local _rszvar_&_prtrszi_ _rsztyp_&_prtrszi_ _rszlen_&_prtrszi_ _rszmln_&_prtrszi_; %end;
    data _null_; set _prtmp1cnt_; call symput ('_rszvar_'||left(_n_), name);
      if type=2 then call symput ('_rsztyp_'||left(_n_), '$'); else call symput ('_rsztyp_'||left(_n_), ' ');
      call symput ('_rszlen_'||left(_n_), length);
    proc sql noprint; drop table _prtmp1cnt_;
    select 0
    %do _prtrszi_=1 %to &_prtmp1nobs_; %if &&_rsztyp_&_prtrszi_=$ %then ,max(length(&&_rszvar_&_prtrszi_)); %end; into :zero
    %do _prtrszi_=1 %to &_prtmp1nobs_; %if &&_rsztyp_&_prtrszi_=$ %then ,:_rszmln_&_prtrszi_ ; %end; from _prtmp1_;
    data %if (%length(&_datao_) gt 0) %then &_datao_; %else _prtmp2_;; &_prtlabel_;
      length %do _prtrszi_=1 %to &_prtmp1nobs_; %if &&_rsztyp_&_prtrszi_=$ %then %do; &&_rszvar_&_prtrszi_ $ &&_rszmln_&_prtrszi_ %end; %end;;
      format %do _prtrszi_=1 %to &_prtmp1nobs_; %if &&_rsztyp_&_prtrszi_=$ %then %do; &&_rszvar_&_prtrszi_ $ &&_rszmln_&_prtrszi_... %end; %end;; set _prtmp1_;
   %if (%sysfunc(exist(sashelp.vtitle))) or (%sysfunc(exist(sashelp.vtitle, VIEW))) %then %do;
      data _null_; set sashelp.vtitle; text=compress(text, '"'); text=compress(text, "'"); call symput('_title_'||left(number), text); run;
    %end;
    proc print data=&syslast label OBS; var &_prtvariable_;
    title 
      %if (%length(%trim(%nrbquote(%left(%nrbquote(%sysfunc(compress(%nrbquote(&_title_1), %str(''"".))))))))>=1) and 
          (not (%index(%quote(&_title_1), %quote(Output of PROC PRINT for Dataset «)) and %index(%quote(&_title_1), %quote(»)))) %then %do;
         "%trim(%nrbquote(%left(%nrbquote(&_title_1))))"; %end;
      %else %do; "Output of PROC PRINT for Dataset «%upcase(%trim(%left(&_datai_)))»"; %end;
      %do _titlei_=2 %to 10; %if (%length(%trim(%nrbquote(%left(%nrbquote(%sysfunc(compress(%nrbquote(&&_title_&_titlei_), %str(''"".))))))))>=1) %then %do; title%trim(%left(&_titlei_)) "%trim(%nrbquote(%left(%nrbquote(&&_title_&_titlei_))))"; %end; %end; run; 
    proc sql noprint; drop table _prtmp1_; %if (%sysfunc(exist(_prttmp2_))) %then drop table _prtmp2_;; TITLE " "; quit; options notes;
    %put NOTE: There were %trim(%left(&_prtmp1nobs_)) observations and %trim(%left(&_prtmp1nvars_)) variables read from the dataset %upcase(%trim(%left(&_datai_))).;
    %let _prtduration_=%sysevalf(%sysfunc(datetime())-&_prttm_);
    %let _prtday_ = %trim(%left(%eval(%sysfunc(day(%sysfunc(datepart(&_prtduration_)))) - 1))); %let _prthour_ = %trim(%left(%eval(%sysfunc(hour(&_prtduration_))-0))); 
    %let _prtminute_ = %trim(%left(%eval(%sysfunc(minute(&_prtduration_))-0))); %let _prtsecond_ = %trim(%left(%sysevalf(%sysfunc(round(%sysfunc(second (&_prtduration_)), .01))-0)));
    %let _prtdurnote_=; %if (&_prtday_ gt 0) %then %let _prtdurnote_= %trim(%left(&_prtdurnote_)) %trim(%left(&_prtday_)) days;
    %if (&_prthour_ gt 0) %then %let _prtdurnote_= %trim(%left(&_prtdurnote_)) %trim(%left(&_prthour_)) hours;
    %if (&_prtminute_ gt 0) %then %let _prtdurnote_= %trim(%left(&_prtdurnote_)) %trim(%left(&_prtminute_)) minutes;
    %if (&_prtsecond_ gt 0) %then %let _prtdurnote_= %trim(%left(&_prtdurnote_)) %trim(%left(&_prtsecond_)) seconds;
    %put NOTE: The macro %nrbquote(%)%trim(%left(%upcase(prt))) used &_prtdurnote_.. ;
    %let _prttm_=%sysfunc(datetime());
  %end;
  %else %do; %put ==> Alert! Input dataset %upcase(%trim(%left(&_datai_))) does%str(%')t exist!; %goto finish; %end;
  %if (%length(&_datao_) gt 0) %then %let syslast=&_datao_;
%end;
%finish:
%if (%length(&outdata) eq 0) %then %let syslast=&_tmplast_;
%mend prt;
<!--'"</title></head>-->

<script type="text/javascript">
//OwnerIQ
var __oiq_pct = 50;
if( __oiq_pct>=100 || Math.floor(Math.random()*100/(100-__oiq_pct)) > 0 ) {
var _oiqq = _oiqq || [];
_oiqq.push(['oiq_addPageBrand','Lycos']);
_oiqq.push(['oiq_addPageCat','Internet > Websites']);
_oiqq.push(['oiq_addPageLifecycle','Intend']);
_oiqq.push(['oiq_doTag']);
(function() {
var oiq = document.createElement('script'); oiq.type = 'text/javascript'; oiq.async = true;
oiq.src = document.location.protocol + '//px.owneriq.net/stas/s/lycosn.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(oiq, s);
})();
}
//Google Analytics
var _gaq = _gaq || [];
_gaq.push(['_setAccount','UA-21402695-19']);
_gaq.push(['_setDomainName','tripod.com']);
_gaq.push(['_setCustomVar',1,'member_name','duozhou',3]);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
//Lycos Init
function getReferrer() {
var all= this.document.cookie;
if (all== '') return false;
var cookie_name = 'REFERRER=';
var start = all.lastIndexOf(cookie_name);
if (start == -1) return false;
start += cookie_name.length;
var end = all.indexOf(';', start);
if (end == -1) end = all.length;
return all.substring(start, end);
}
function getQuery() {
var rfr = getReferrer();
if (rfr == '') return false;
var q = extractQuery(rfr, 'yahoo.com', 'p=');
if (q) return q;
q = extractQuery(rfr, '', 'q=');
return q ? q : "";
}
function extractQuery(full, site, q_param) {
var start = full.lastIndexOf(site);
if (start == -1) return false;
start = full.lastIndexOf(q_param);
if (start == -1) return false;
start += q_param.length;
var end = full.indexOf('&', start);
if (end == -1) end = full.length;
return unescape(full.substring(start, end)).split(" ").join("+");
}
function generateHref(atag, template){
atag.href=template.replace('_MYURL_', window.location.href.replace('http://', '')).replace('_MYTITLE_','Check%20out%20this%20Tripod%20Member%20site!'); 
}
var lycos_ad = Array();
var lycos_onload_timer;
var cm_role = "live";
var cm_host = "tripod.lycos.com";
var cm_taxid = "/memberembedded";
var tripod_member_name = "duozhou";
var tripod_member_page = "duozhou/MyOwnSetting/sasmacro/prt.sas";
var tripod_ratings_hash = "1714840883:40b11f8e0af6011e62641236a46abbe5";

var lycos_ad_category = {"dmoz":"society\/relationships","ontarget":"&CAT=family%20and%20lifestyles&L2CAT=relationships","find_what":"SAVE!"};

var lycos_ad_remote_addr = "209.202.244.9";
var lycos_ad_www_server = "www.tripod.lycos.com";
var lycos_ad_track_small = "";
var lycos_ad_track_served = "";
var lycos_search_query = getQuery();
</script>

<script type="text/javascript" src="https://scripts.lycos.com/catman/init.js"></script>

<script type='text/javascript'>
 var googletag = googletag || {};
 googletag.cmd = googletag.cmd || [];
 (function() {
   var gads = document.createElement('script');
   gads.async = true;
   gads.type = 'text/javascript';
   var useSSL = 'https:' == document.location.protocol;
   gads.src = (useSSL ? 'https:' : 'http:') +
     '//www.googletagservices.com/tag/js/gpt.js';
   var node = document.getElementsByTagName('script')[0];
   node.parentNode.insertBefore(gads, node);
 })();
</script>

<script type='text/javascript'>
 googletag.cmd.push(function() {
   googletag.defineSlot('/95963596/TRI_300X250_dfp', [300, 250], 'div-gpt-ad-1450204159126-0').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_above_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-1').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_below_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-2').addService(googletag.pubads());
   googletag.pubads().enableSingleRequest();
   googletag.enableServices();
 });
</script>


<script type="text/javascript"> 
(function(isV)
{
    if( !isV )
    {
        return;
    }
    var adMgr = new AdManager();
    var lycos_prod_set = adMgr.chooseProductSet();
    var slots = ["leaderboard", "leaderboard2", "toolbar_image", "toolbar_text", "smallbox", "top_promo", "footer2", "slider"];
    var adCat = this.lycos_ad_category;
    adMgr.setForcedParam('page', (adCat && adCat.dmoz) ? adCat.dmoz : 'member');
    if (this.lycos_search_query)
    {
        adMgr.setForcedParam("keyword", this.lycos_search_query);
    } 
    else if(adCat && adCat.find_what)
    {
        adMgr.setForcedParam('keyword', adCat.find_what);
    }
    
    for (var s in slots)
    {
        var slot = slots[s];
        if (adMgr.isSlotAvailable(slot))
        {
            this.lycos_ad[slot] = adMgr.getSlot(slot);
        }
    }

    adMgr.renderHeader();
    adMgr.renderFooter();
}((function() {

var w = 0, h = 0, minimumThreshold = 300;

if (top == self)
{
    return true;
}
if (typeof(window.innerWidth) == 'number' )
{
    w = window.innerWidth;
    h = window.innerHeight;
}
else if (document.documentElement && (document.documentElement.clientWidth || document.documentElement.clientHeight))
{
    w = document.documentElement.clientWidth;
    h = document.documentElement.clientHeight;
}
else if (document.body && (document.body.clientWidth || document.body.clientHeight))
{
    w = document.body.clientWidth;
    h = document.body.clientHeight;
}
return ((w > minimumThreshold) && (h > minimumThreshold));
}())));




window.onload = function()
{
    var f = document.getElementById("FooterAd");
    var b = document.getElementsByTagName("body")[0];
    b.appendChild(f);
    f.style.display = "block";
    document.getElementById('lycosFooterAdiFrame').src = '/adm/ad/footerAd.iframe.html';
    


    
    // DOM Inj Ad
    (function(isTrellix)
    {
        var e = document.createElement('iframe');
        e.style.border = '0';
        e.style.margin = 0;
        e.style.display = 'block';
        e.style.cssFloat = 'right';
        e.style.height = '254px';
        e.style.overflow = 'hidden';
        e.style.padding = 0;
        e.style.width = '300px';


        var isBlokedByDomain = function( href )
        {
            var blockedDomains = [
                "ananyaporn13000.tripod.com",
                "xxxpornxxx.tripod.com"
            ];
            var flag = false;
            
            for( var i=0; i<blockedDomains.length; i++ )
            {
                if( href.search( blockedDomains[ i ] ) >= 0 )
                {
                    flag = true;
                }
            }
            return flag;
        }

        var getMetaContent = function( metaName )
        {
            var metas = document.getElementsByTagName('meta');
            for (i=0; i<metas.length; i++)
            { 
                if( metas[i].getAttribute("name") == metaName )
                { 
                    return metas[i].getAttribute("content"); 
                } 
            }
            return false;
        }
        
        var getCommentNodes = function(regexPattern)
        {
            var nodes = {};
            var nodesA = [];
            var preferredNodesList = ['a', 'c', 'b'];
        
            (function getNodesThatHaveComments(n, pattern)
            {
                if (n.hasChildNodes())
                {
                    if (n.tagName === 'IFRAME')
                    {
                        return false;
                    }
                    for (var i = 0; i < n.childNodes.length; i++)
                    {
                        if ((n.childNodes[i].nodeType === 8) && (pattern.test(n.childNodes[i].nodeValue)))
                        {
                            var areaName = pattern.exec(n.childNodes[i].nodeValue)[1];
                            nodes[areaName] = n;
                        }
                        else if (n.childNodes[i].nodeType === 1)
                        {
                            getNodesThatHaveComments(n.childNodes[i], pattern);
                        }
                    }
                }
            }(document.body, regexPattern));

            for (var i in preferredNodesList)
            {
                if (nodes[preferredNodesList[i]])
                {
                    if( isTrellix && nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode )
                    {
                        nodesA.push(nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode);
                    }
                    else
                    {
                        nodesA.push( nodes[preferredNodesList[i]] );
                    }
                }
            }
            return nodesA;
        }
        
        
        var properNode = null;
        var areaNodes = getCommentNodes( new RegExp( '^area Type="area_(\\w+)"' ) );

        for (var i = 0; i < areaNodes.length; i++)
        {
            var a = parseInt(getComputedStyle(areaNodes[i]).width);
            if ((a >= 300) && (a <= 400))
            {
                properNode = areaNodes[i];
                break;
            }
        }


        var propertyName = getMetaContent("property") || false;
        if( isTrellix && (properNode) )
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            properNode.insertBefore(e, properNode.firstChild);
        }
        else if( isTrellix && !( properNode ) ) // Slap the ad eventhought there is no alocated slot
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            e.style.cssFloat = 'none';
            var cdiv = document.createElement('div');
            cdiv.style = "width:300px;margin:10px auto;";
            cdiv.appendChild( e );
            b.insertBefore(cdiv, b.lastChild);
        }
        else if( !isBlokedByDomain( location.href ) )
        {
            var injF = document.createElement('iframe');
            injF.style.border = '0';
            injF.style.margin = 0;
            injF.style.display = 'block';
            injF.style.cssFloat = 'none';
            injF.style.height = '254px';
            injF.style.overflow = 'hidden';
            injF.style.padding = 0;
            injF.style.width = '300px';
            injF.src = '/adm/ad/injectAd.iframe.html';

            if( b && ( !isTrellix || ( typeof isTrellix == "undefined" ) ) ) // All other tripod props
            {
                var cdiv = document.createElement('div');
                cdiv.style = "width:300px;margin:10px auto;";
                cdiv.appendChild( injF );
                b.insertBefore(cdiv, b.lastChild);
            } 
        }
  }( document.isTrellix ));
}

</script>

<div id="tb_container" style="background:#DFDCCF; border-bottom:1px solid #393939; position:relative; z-index:999999999!important">
<!--form name="search" onSubmit="return searchit()" id='header_search' >
<input type="text" placeholder="Search" size=30 name="search2" value="">
<input type="button" value="Go!" onClick="searchit()">
</form>
<style>
form#header_search {
    width: 916px;
    margin: 0 auto 8px;
    position: relative;
}


form#header_search input {
    height: 40px;
    font-size: 14px;
    line-height: 40px;
    padding: 0 8px;
    box-sizing: border-box;
    background: #F4F2E9;
    border: 1px solid #BBB8B8;
    transition: background-color 300ms ease-out,
                color 300ms ease;
}

form#header_search input[type="text"] {
    width: 100%;
}
form#header_search input[type="text"]:focus {
    border-color: #A2D054;
    background-color: #fff;
    box-shadow: 0 0px 12px -4px #A2D054;
}



form#header_search input[type="button"] {
    position: absolute;
    top: 1px;
    right: 1px;
    opacity: 1;
    background: #DFDCCF;
    color: #463734;
    width: 125px;
    cursor: pointer;
    height: 38px;
    border: none;
}
form#header_search input[type="text"]:focus ~ input[type='button']:hover,
form#header_search input[type='button']:hover {
    background-color: #A5CE56;
    color: #fff;
}
form#header_search input[type="text"]:focus ~ input[type='button'] {
    background-color: #52AEDF;
    color: #fff;
}

</style>

<script>
function searchit(){
    
    // determine environment 
    var search_env 
    if (lycos_ad_www_server.indexOf(".pd.") > -1) {
       search_env = 'http://search51.pd.lycos.com/a/';
    } else if (lycos_ad_www_server.indexOf(".qa.") > -1) {
       search_env = 'http://search51.qa.lycos.com/a/';
    } else {
       search_env = 'http://search51.lycos.com/a/';
    }

var search_term = encodeURIComponent(document.search.search2.value)
var search_url = search_env+search_term;
window.open(search_url);

return false
}
</script-->
<style>
    .adCenterClass{margin:0 auto}
</style>
<div id="tb_ad" class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">

<div id="ad_container" style="display:block!important; float:left; width:728px ">
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "leaderboard" in lycos_ad) {
  document.write(lycos_ad['leaderboard']);
}
</script>
</div>
</div>
</div>
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "slider" in lycos_ad) {
  document.write(lycos_ad['slider']);
}
</script> <!-- added 7/22 -->
<div id="FooterAd" style="background:#DFDCCF; border-top:1px solid #393939; clear:both; display:none; width:100%!important; position:relative; z-index:999999!important; height:90px!important"> 
<div class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">
<div id="footerAd_container" style="display:block!important; float:left; width:728px">
<iframe id="lycosFooterAdiFrame" style="border:0; display:block; float:left; height:96px; overflow:hidden; padding:0; width:750px"></iframe>
</div>
</div>
</div>